package com.sun.pojo;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
//@ContentRowHeight//行高
//@HeadRowHeight//表头的行高
public class Student {
    /**
     * ExcelProperty
     *      value: excel表中对应的名字
     */
    //@ExcelProperty(value = "学生姓名",index = 0)
//    @ExcelProperty(value = {"学院信息表","学生姓名"})
    @ColumnWidth(20)//列宽
    private String name;

    //@ExcelProperty(value = "学生性别",index = 1)
//    @ExcelProperty(value = {"学院信息表","学生性别"})
    private String gender;

    @ColumnWidth(20)
    //@ExcelProperty(value = "学生出生日期",index = 2)
//    @ExcelProperty(value = {"学院信息表","学生出生日期"})
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    private Date birthday;

//    @ExcelProperty(value = "ID",index = 0)
    @ExcelIgnore
    private Integer id;
}
